Replaces all occurrences of string_exp2 in string_exp1 with string_exp3
Format
SQL Format:Replace( string_exp1, string_exp2, string_exp3 )
ODBC Format:
{{ FN Replace( string_exp1, string_exp2, string_exp3 ) }}
Remarks
Returns a string expression that reads like string_exp1 except that any occurrences of string_exp2 therein will have been replaced by string_exp3.
string_exp1 can be any string expression.
string_exp2 can be any string expression.
string_exp3 can be any string expression.
Example:
Replace( 'I drove to the market', 'drove', 'cycled' )
{FN Replace( 'I drove to the market', 'drove', 'cycled' )}
returns the string expression 'I cycled to the market'.